OpenEdge Data Management:<br />SQL Reference SQLCursor.registerOutParam

Release 10.1A: OpenEdge Data Management:
SQL Reference

SQLCursor.registerOutParam

Registers OUT parameters.

Format

registerOutParam( int fieldIndex, short fieldType [ , short scale ] )

Returns

None

Parameters
fieldIndex
An integer that specifies the position of the parameter in the parameter list.
fieldType
A short integer that specifies the data type of the parameter. The allowable defined values for fieldType are listed in Table 57, grouped by category of data type.

Table 57: Allowable values for fieldType in registerOutParam

Character

Exact numeric

Approximate numeric

Date-time

Bit string

CHAR

INTEGER

REAL

DATE

BIT

CHARACTER

SMALLINT

FLOAT

TIME

BINARY

VARCHAR

TINYINT

DOUBLE

TIMESTAMP

VARBINARY

–

NUMERIC

–

–

LVARBINARY

–

DECIMAL

–

–

–

Throws

DhSQLException

Character	Exact numeric	Approximate numeric	Date-time	Bit string
`CHAR`	`INTEGER`	`REAL`	`DATE`	`BIT`
`CHARACTER`	`SMALLINT`	`FLOAT`	`TIME`	`BINARY`
`VARCHAR`	`TINYINT`	`DOUBLE`	`TIMESTAMP`	`VARBINARY`
–	`NUMERIC`	–	–	`LVARBINARY`
–	`DECIMAL`	–	–	–